SELECT ident, naziv,IF( slika_1 IS NULL ,'/gfx/_box-images/ni_slike.jpg',slika_1) as slika_1,cena_pred_akcijo,cena FROM _produkti_aures
WHERE kategorija = 'Čelade Airoh' AND pod_kategorija = 'Kros' AND stil = 'Polikarbonat'
ORDER BY cena LIMIT 9,9
Airoh Wraap ALIEN RED MATT
175,99 €
Airoh Wraap ALIEN YELLOW MATT
175,99 €
Airoh Twist Iron
179,99 €
Airoh Twist Crazy
179,99 €
Airoh Twist Great
179,99 €
Airoh Twist 2.0 Color BELA
209,99 €
Airoh Twist 2.0 Color ČRNA
209,99 €
Airoh Twist 2.0 Frame
220,10 €
Airoh Twist 2.0 Katana
220,10 €